package com.jiuwu.spring.eshop.db.entity;

import lombok.Data;
import lombok.NoArgsConstructor;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "V_Member")
@Data
@NoArgsConstructor
public class VMember {




//    SELECT     dbo.tb_member.MemberID,
//    dbo.tb_member.MemberTrueName,
//    dbo.tb_member.MemberCity,
//    dbo.tb_member.MemberName,
//    dbo.tb_member.MemberAddress,
//    dbo.tb_member.MemberPostcode,
//    dbo.tb_member.MemberCardNO,
//    dbo.tb_member.MemberCardType,
//    dbo.tb_member.MemberGrade,
//    dbo.tb_member.MemberAmount
//    dbo.tb_rebate.rebate,
//    dbo.tb_member.MemberID AS Expr1
//    FROM         dbo.tb_member INNER JOIN
//    dbo.tb_rebate ON dbo.tb_member.MemberGrade = dbo.tb_rebate.grade

    @Id
    @Column(name = "MemberID")
    public Integer id;


    @Column(name="MemberName")
    private String name;

    @Column(name="MemberGrade")
    private String grade;


    @Column(name="rebate")
    private float rebate;


    @Column(name="MemberAmount")
    private float amount;



}
